How to: Change properties of an existing field of a table.
Solution:
In the Table Design view, select the field and make the desired changes in the 'Field Properties' section.
1) If the Database window is not active, activate the Database window.
2) Go to the Table' Design view:
a) Click the 'Table' tab in the Database window.
Tables tab
b) Select the desired table from the list.
c) Click 'Design'. (The Table Design window appears.)
3) Click in the field for which to change properties:
4) Move to the 'Field Properties' section.
Field Properties section
5) Click the 'General' tab.
6) Make the desired changes to the field properties.
7) Click the 'Lookup' tab.
8) Make the desired changes to the field properties.
9) Select the 'File' menu and select 'Save' to save the changes.
10) Select the 'File' menu and select 'Close' to close the Table Design window.
NOTE: It is a good idea to set a table's field properties BEFORE entering data. Changing properties of an existing field may create complications. For example, decreasing the size of a text field may truncate some of the data typed in the field, and the lost information cannot be restored.
